package com.trade.module.daq.entity;

import com.trade.module.base.entity.BaseEntity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import java.io.Serializable;

/**
 * Class Description: 系统信息实体类
 *
 * @Version v1.0 2017/6/17 12:13
 * @JDK version 1.8.0_51
 * @Author zfb
 */
@Entity
@Table(name = "daq_system_info")
public class SystemInfo extends BaseEntity implements Serializable{
    private static final long serialVersionUID = -6374644877484961409L;

    @Column(
            name = "cname",
            length = 32)
    private String cname;//	系统名称
    @Column(
            name = "ip",
            length = 32
    )
    private String ip;//	数据库ip地址
    @Column(
            name = "password",
            length = 32
    )
    private String password;//	数据库密码
    @Column(
            name = "username",
            length = 32)
    private String username;//	数据库登陆用户
    @Column(
            name = "da_type",
            length = 32
    )
    private String dbType;//	数据库类型(ORACLE:1,DM:2,MYSQL:3,SQL_SERVER:4)
    @Column(
            name = "db_name",
            length = 32
    )
    private String dbName;//	数据库实例名称
    @Column(
            name = "url",
            length = 255)
    private String url;//URL
    @Column(
            name = "remark",
            length = 120)
    private String remark;//	备注
    @Column(
            name = "port",
            length = 10)
    private String port;//	数据库端口
    @Column(
            name = "if_use",
            length = 4)
    private String ifUse;//	使用状态
    @Column(
            name = "reserve",
            length = 32
    )
    private String reserve;//	预留字段
    @Column(
            name = "surperiod",
            length = 32
    )
    private String surperiod;//	生存周期
    @Column(
            name = "center_db_id",
            length = 64)
    private String centerDBId;//	中心库系统连接id
    @Column(
            name = "origin",
            length = 4)
    private String origin;//	库来源（1：数据管理:2：目标资源 ）
    @Column(
            name = "rel_sys_id",
            length = 80)
    private String relSysId;  //关联系统ID

    public String getCname() {
        return cname;
    }

    public void setCname(String cname) {
        this.cname = cname;
    }

    public String getIp() {
        return ip;
    }

    public void setIp(String ip) {
        this.ip = ip;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getDbType() {
        return dbType;
    }

    public void setDbType(String dbType) {
        this.dbType = dbType;
    }

    public String getDbName() {
        return dbName;
    }

    public void setDbName(String dbName) {
        this.dbName = dbName;
    }

    public String getUrl() {
        return url;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

    public String getPort() {
        return port;
    }

    public void setPort(String port) {
        this.port = port;
    }

    public String getIfUse() {
        return ifUse;
    }

    public void setIfUse(String ifUse) {
        this.ifUse = ifUse;
    }

    public String getReserve() {
        return reserve;
    }

    public void setReserve(String reserve) {
        this.reserve = reserve;
    }

    public String getSurperiod() {
        return surperiod;
    }

    public void setSurperiod(String surperiod) {
        this.surperiod = surperiod;
    }

    public String getCenterDBId() {
        return centerDBId;
    }

    public void setCenterDBId(String centerDBId) {
        this.centerDBId = centerDBId;
    }

    public String getOrigin() {
        return origin;
    }

    public void setOrigin(String origin) {
        this.origin = origin;
    }

    public String getRelSysId() {
        return relSysId;
    }

    public void setRelSysId(String relSysId) {
        this.relSysId = relSysId;
    }

}
